Synergy System Overtime Database Query

This documentation describes the details of the SQL query that will be used to retrieve the overtime information held in the Synergy system from the database.

Overtime Inquiry

We can use the following SQL query to get the overtime information under Human Resources in the web interface.

Query Detail

'''SQL SELECT O.CODE, O.FACTOR, OML.NAME FROM OVERTIMES AS O INNER JOIN OVERTIMESML AS OML ON OML. OVERTIMEID = O.ID AND OML. CULTURE = 'en-US' WHERE O.DELETEDAT IS NULL

This query joins the records from the OVERTIMES table with the OVERTIMESML table and returns the overtime names in Turkish.

### The description of INNER JOIN App

The use of 'INNER JOIN' associates each overtime record with its multi-language table, OVERTIMESML. This association is done through the 'OVERTIMEID' and 'ID' fields. Also, you can use the 'OML. With the condition CULTURE = 'tr-TR', we bring only the names of the works in Turkish.

### WHERE Condition Explanation

The condition 'WHERE O.DELETEDAT IS NULL' excludes the deleted overtime records from the query result. This condition is used to retrieve only valid (undeleted) overtime information from the database.

This query can be used to access overtime information while working under the Human Resources module in the Synergy system and can be easily integrated.